From da5d12a08d338e591f117e9fc2f83287e819506c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 31 Jul 2026 21:13:50 +0000 Subject: [PATCH] Correct the privileges of SWELLING_STATES --- db/schemas/sokwedb/functions/create/build_swelling_states.m4 | 2 +- db/schemas/sokwedb/tables/create/swelling_states.m4 | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/db/schemas/sokwedb/functions/create/build_swelling_states.m4 b/db/schemas/sokwedb/functions/create/build_swelling_states.m4 index 25cb0e7..2a4acc5 100644 --- a/db/schemas/sokwedb/functions/create/build_swelling_states.m4 +++ b/db/schemas/sokwedb/functions/create/build_swelling_states.m4 @@ -28,7 +28,7 @@ CREATE OR REPLACE FUNCTION build_swelling_states() RETURNS INT LANGUAGE plpgsql VOLATILE - SECURITY INVOKER + SECURITY DEFINER PARALLEL UNSAFE sdb_function_set_search_path AS $$ diff --git a/db/schemas/sokwedb/tables/create/swelling_states.m4 b/db/schemas/sokwedb/tables/create/swelling_states.m4 index b2d25fc..be2a84c 100644 --- a/db/schemas/sokwedb/tables/create/swelling_states.m4 +++ b/db/schemas/sokwedb/tables/create/swelling_states.m4 @@ -37,4 +37,4 @@ CREATE TABLE swelling_states ( REFERENCES sighting_records ); -grant_priv(`SWELLING_STATES') +grant_ro_priv(`SWELLING_STATES') -- 2.34.1